select create_date, url, media, title, top_time, top_num, create_time, time, comment_url, newsid, leadernews, autoid, geotagcmt, bjkmgzcdcmt, cmt, paidcmt, bertp, infoshow, infototal, bertac, governmentsource, governmentmedia, subsidizedmedia, commercialmedia, name_en 
from sinanews
where time::timestamp > '20100615' and time::timestamp < '20150615'
